Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 348283 |
| Missing cells | 53854 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 37.2 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 1 |
|---|---|
| DateTime | 3 |
| Numeric | 9 |
| Text | 1 |
VERSIE has constant value "" | Constant |
DATUM_BESTAND has constant value "" | Constant |
PEILDATUM has constant value "" | Constant |
GEMIDDELDE_VERKOOPPRIJS has 53854 (15.5%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.35699905) | Skewed |
Reproduction
| Analysis started | 2024-01-08 15:06:28.890315 |
|---|---|
| Analysis finished | 2024-01-08 15:06:45.452753 |
| Duration | 16.56 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
VERSIE
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1044849 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 348283 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 348283 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 348283 | |
| . | 348283 | |
| 0 | 348283 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 696566 | |
| Other Punctuation | 348283 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 348283 | |
| 0 | 348283 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 348283 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1044849 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 348283 | |
| . | 348283 | |
| 0 | 348283 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1044849 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 348283 | |
| . | 348283 | |
| 0 | 348283 |
DATUM_BESTAND
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| Minimum | 2023-12-08 00:00:00 |
|---|---|
| Maximum | 2023-12-08 00:00:00 |
Histogram with fixed size bins (bins=1)
PEILDATUM
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| Minimum | 2023-12-01 00:00:00 |
|---|---|
| Maximum | 2023-12-01 00:00:00 |
Histogram with fixed size bins (bins=1)
JAAR
Date
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2023-01-01 00:00:00 |
Histogram with fixed size bins (bins=12)
BEHANDELEND_SPECIALISME_CD
Real number (ℝ)
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 451.5876 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 301 |
|---|---|
| 5-th percentile | 302 |
| Q1 | 305 |
| median | 313 |
| Q3 | 322 |
| 95-th percentile | 361 |
| Maximum | 8418 |
| Range | 8117 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 1041.0915 |
|---|---|
| Coefficient of variation (CV) | 2.3054033 |
| Kurtosis | 54.470481 |
| Mean | 451.5876 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.5099326 |
| Sum | 1.5728028 × 108 |
| Variance | 1083871.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 48900 | |
| 313 | 45230 | |
| 303 | 40083 | |
| 330 | 27420 | 7.9% |
| 316 | 23684 | 6.8% |
| 308 | 18857 | 5.4% |
| 306 | 14642 | 4.2% |
| 324 | 14315 | 4.1% |
| 301 | 13901 | 4.0% |
| 304 | 11326 | 3.3% |
| Other values (18) | 89925 |
| Value | Count | Frequency (%) |
| 301 | 13901 | 4.0% |
| 302 | 7656 | 2.2% |
| 303 | 40083 | |
| 304 | 11326 | 3.3% |
| 305 | 48900 | |
| 306 | 14642 | 4.2% |
| 307 | 6120 | 1.8% |
| 308 | 18857 | 5.4% |
| 310 | 3802 | 1.1% |
| 313 | 45230 |
| Value | Count | Frequency (%) |
| 8418 | 4683 | 1.3% |
| 8416 | 1156 | 0.3% |
| 1900 | 229 | 0.1% |
| 390 | 957 | 0.3% |
| 389 | 3650 | 1.0% |
| 362 | 4469 | 1.3% |
| 361 | 2538 | 0.7% |
| 335 | 3505 | 1.0% |
| 330 | 27420 | |
| 329 | 909 | 0.3% |
| Distinct | 1902 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.3530405 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1167807 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 11 |
|---|---|
| 2nd row | 11 |
| 3rd row | 13 |
| 4th row | 12 |
| 5th row | 11 |
| Value | Count | Frequency (%) |
| 101 | 1485 | 0.4% |
| 402 | 1428 | 0.4% |
| 403 | 1400 | 0.4% |
| 301 | 1397 | 0.4% |
| 201 | 1327 | 0.4% |
| 203 | 1298 | 0.4% |
| 401 | 1169 | 0.3% |
| 404 | 1158 | 0.3% |
| 409 | 1128 | 0.3% |
| 802 | 1126 | 0.3% |
| Other values (1892) | 335367 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 223286 | |
| 0 | 214598 | |
| 2 | 154768 | |
| 3 | 126335 | |
| 5 | 90131 | |
| 9 | 84059 | 7.2% |
| 4 | 82672 | 7.1% |
| 7 | 68820 | 5.9% |
| 6 | 61006 | 5.2% |
| 8 | 50327 | 4.3% |
| Other values (15) | 11805 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1156002 | |
| Uppercase Letter | 11805 | 1.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 2198 | |
| M | 1990 | |
| B | 1429 | |
| Z | 1030 | |
| E | 987 | |
| D | 778 | 6.6% |
| A | 763 | 6.5% |
| F | 732 | 6.2% |
| C | 388 | 3.3% |
| K | 379 | 3.2% |
| Other values (5) | 1131 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 223286 | |
| 0 | 214598 | |
| 2 | 154768 | |
| 3 | 126335 | |
| 5 | 90131 | |
| 9 | 84059 | 7.3% |
| 4 | 82672 | 7.2% |
| 7 | 68820 | 6.0% |
| 6 | 61006 | 5.3% |
| 8 | 50327 | 4.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1156002 | |
| Latin | 11805 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 2198 | |
| M | 1990 | |
| B | 1429 | |
| Z | 1030 | |
| E | 987 | |
| D | 778 | 6.6% |
| A | 763 | 6.5% |
| F | 732 | 6.2% |
| C | 388 | 3.3% |
| K | 379 | 3.2% |
| Other values (5) | 1131 |
Common
| Value | Count | Frequency (%) |
| 1 | 223286 | |
| 0 | 214598 | |
| 2 | 154768 | |
| 3 | 126335 | |
| 5 | 90131 | |
| 9 | 84059 | 7.3% |
| 4 | 82672 | 7.2% |
| 7 | 68820 | 6.0% |
| 6 | 61006 | 5.3% |
| 8 | 50327 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1167807 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 223286 | |
| 0 | 214598 | |
| 2 | 154768 | |
| 3 | 126335 | |
| 5 | 90131 | |
| 9 | 84059 | 7.2% |
| 4 | 82672 | 7.1% |
| 7 | 68820 | 5.9% |
| 6 | 61006 | 5.2% |
| 8 | 50327 | 4.3% |
| Other values (15) | 11805 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6231 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4125155 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999040 |
| Q1 | 99899009 |
| median | 1.4959903 × 108 |
| Q3 | 9.9000302 × 108 |
| 95-th percentile | 9.9051605 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9010402 × 108 |
Descriptive statistics
| Standard deviation | 4.2904666 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.9723403 |
| Kurtosis | -1.7393726 |
| Mean | 4.4125155 × 108 |
| Median Absolute Deviation (MAD) | 1.1960003 × 108 |
| Skewness | 0.46549346 |
| Sum | 1.5368041 × 1014 |
| Variance | 1.8408104 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2538 | 0.7% |
| 990004007 | 2496 | 0.7% |
| 990003004 | 2411 | 0.7% |
| 990004006 | 2038 | 0.6% |
| 990356076 | 1855 | 0.5% |
| 990356073 | 1724 | 0.5% |
| 131999228 | 1704 | 0.5% |
| 131999164 | 1681 | 0.5% |
| 990003007 | 1559 | 0.4% |
| 131999194 | 1534 | 0.4% |
| Other values (6221) | 328743 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 12 | |
| 10501004 | 12 | |
| 10501005 | 12 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 12 | |
| 10501010 | 12 | |
| 10501011 | 3 | < 0.1% |
| 11101002 | 11 | |
| 11101003 | 12 |
| Value | Count | Frequency (%) |
| 998418081 | 178 | |
| 998418080 | 161 | |
| 998418079 | 40 | < 0.1% |
| 998418077 | 9 | < 0.1% |
| 998418076 | 9 | < 0.1% |
| 998418075 | 7 | < 0.1% |
| 998418074 | 240 | |
| 998418073 | 241 | |
| 998418072 | 9 | < 0.1% |
| 998418071 | 9 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
| Distinct | 10529 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 514.81051 |
| Minimum | 1 |
|---|---|
| Maximum | 165184 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 103 |
| 95-th percentile | 1747.9 |
| Maximum | 165184 |
| Range | 165183 |
| Interquartile range (IQR) | 100 |
Descriptive statistics
| Standard deviation | 3186.1044 |
|---|---|
| Coefficient of variation (CV) | 6.1888876 |
| Kurtosis | 413.453 |
| Mean | 514.81051 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 16.802664 |
| Sum | 1.7929975 × 108 |
| Variance | 10151261 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 57632 | 16.5% |
| 2 | 28139 | 8.1% |
| 3 | 18421 | 5.3% |
| 4 | 13446 | 3.9% |
| 5 | 10519 | 3.0% |
| 6 | 8920 | 2.6% |
| 7 | 7406 | 2.1% |
| 8 | 6238 | 1.8% |
| 9 | 5678 | 1.6% |
| 10 | 5097 | 1.5% |
| Other values (10519) | 186787 |
| Value | Count | Frequency (%) |
| 1 | 57632 | |
| 2 | 28139 | |
| 3 | 18421 | 5.3% |
| 4 | 13446 | 3.9% |
| 5 | 10519 | 3.0% |
| 6 | 8920 | 2.6% |
| 7 | 7406 | 2.1% |
| 8 | 6238 | 1.8% |
| 9 | 5678 | 1.6% |
| 10 | 5097 | 1.5% |
| Value | Count | Frequency (%) |
| 165184 | 1 | |
| 162460 | 1 | |
| 161431 | 1 | |
| 155869 | 1 | |
| 154540 | 1 | |
| 154258 | 1 | |
| 144714 | 1 | |
| 118396 | 1 | |
| 115935 | 1 | |
| 113249 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
SKEWED
| Distinct | 11324 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 610.12209 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 15 |
| Q3 | 113 |
| 95-th percentile | 1994 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 110 |
Descriptive statistics
| Standard deviation | 4113.8514 |
|---|---|
| Coefficient of variation (CV) | 6.7426692 |
| Kurtosis | 723.91859 |
| Mean | 610.12209 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 21.356999 |
| Sum | 2.1249515 × 108 |
| Variance | 16923773 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 55495 | 15.9% |
| 2 | 27644 | 7.9% |
| 3 | 18238 | 5.2% |
| 4 | 13255 | 3.8% |
| 5 | 10430 | 3.0% |
| 6 | 8888 | 2.6% |
| 7 | 7345 | 2.1% |
| 8 | 6170 | 1.8% |
| 9 | 5596 | 1.6% |
| 10 | 5115 | 1.5% |
| Other values (11314) | 190107 |
| Value | Count | Frequency (%) |
| 1 | 55495 | |
| 2 | 27644 | |
| 3 | 18238 | 5.2% |
| 4 | 13255 | 3.8% |
| 5 | 10430 | 3.0% |
| 6 | 8888 | 2.6% |
| 7 | 7345 | 2.1% |
| 8 | 6170 | 1.8% |
| 9 | 5596 | 1.6% |
| 10 | 5115 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231954 | 1 | |
| 230939 | 1 | |
| 227936 | 1 | |
| 227409 | 1 | |
| 226314 | 1 | |
| 223891 | 1 | |
| 218673 | 1 | |
| 215131 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
| Distinct | 9478 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7724.599 |
| Minimum | 1 |
|---|---|
| Maximum | 232594 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 41 |
| Q1 | 407 |
| median | 1728 |
| Q3 | 6359 |
| 95-th percentile | 36952 |
| Maximum | 232594 |
| Range | 232593 |
| Interquartile range (IQR) | 5952 |
Descriptive statistics
| Standard deviation | 17938.902 |
|---|---|
| Coefficient of variation (CV) | 2.3223084 |
| Kurtosis | 34.821336 |
| Mean | 7724.599 |
| Median Absolute Deviation (MAD) | 1576 |
| Skewness | 5.0992958 |
| Sum | 2.6903465 × 109 |
| Variance | 3.2180419 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21 | 581 | 0.2% |
| 8 | 513 | 0.1% |
| 25 | 512 | 0.1% |
| 9 | 512 | 0.1% |
| 19 | 506 | 0.1% |
| 23 | 504 | 0.1% |
| 17 | 488 | 0.1% |
| 14 | 482 | 0.1% |
| 12 | 479 | 0.1% |
| 4 | 469 | 0.1% |
| Other values (9468) | 343237 |
| Value | Count | Frequency (%) |
| 1 | 386 | |
| 2 | 458 | |
| 3 | 445 | |
| 4 | 469 | |
| 5 | 437 | |
| 6 | 451 | |
| 7 | 438 | |
| 8 | 513 | |
| 9 | 512 | |
| 10 | 416 |
| Value | Count | Frequency (%) |
| 232594 | 22 | |
| 230662 | 23 | |
| 227999 | 23 | |
| 218496 | 24 | |
| 214506 | 17 | |
| 213515 | 25 | |
| 211579 | 17 | |
| 210414 | 19 | |
| 205337 | 17 | |
| 200600 | 16 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
| Distinct | 10607 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11197.494 |
| Minimum | 1 |
|---|---|
| Maximum | 370139 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 52 |
| Q1 | 538 |
| median | 2397 |
| Q3 | 9161 |
| 95-th percentile | 52238 |
| Maximum | 370139 |
| Range | 370138 |
| Interquartile range (IQR) | 8623 |
Descriptive statistics
| Standard deviation | 26927.005 |
|---|---|
| Coefficient of variation (CV) | 2.4047349 |
| Kurtosis | 38.235007 |
| Mean | 11197.494 |
| Median Absolute Deviation (MAD) | 2202 |
| Skewness | 5.3387873 |
| Sum | 3.8998968 × 109 |
| Variance | 7.250636 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 433 | 0.1% |
| 17 | 416 | 0.1% |
| 24 | 414 | 0.1% |
| 23 | 409 | 0.1% |
| 33 | 405 | 0.1% |
| 6 | 389 | 0.1% |
| 4 | 382 | 0.1% |
| 39 | 382 | 0.1% |
| 21 | 378 | 0.1% |
| 20 | 378 | 0.1% |
| Other values (10597) | 344297 |
| Value | Count | Frequency (%) |
| 1 | 298 | |
| 2 | 340 | |
| 3 | 367 | |
| 4 | 382 | |
| 5 | 350 | |
| 6 | 389 | |
| 7 | 357 | |
| 8 | 345 | |
| 9 | 310 | |
| 10 | 374 |
| Value | Count | Frequency (%) |
| 370139 | 23 | |
| 365383 | 23 | |
| 358372 | 22 | |
| 348482 | 25 | |
| 344611 | 24 | |
| 341651 | 19 | |
| 323753 | 20 | |
| 315771 | 17 | |
| 310754 | 17 | |
| 298627 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
| Distinct | 325 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 671239.57 |
| Minimum | 1610 |
|---|---|
| Maximum | 1487630 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1610 |
|---|---|
| 5-th percentile | 41749 |
| Q1 | 287320 |
| median | 757844 |
| Q3 | 1030951 |
| 95-th percentile | 1332293 |
| Maximum | 1487630 |
| Range | 1486020 |
| Interquartile range (IQR) | 743631 |
Descriptive statistics
| Standard deviation | 413732.12 |
|---|---|
| Coefficient of variation (CV) | 0.61637027 |
| Kurtosis | -1.131107 |
| Mean | 671239.57 |
| Median Absolute Deviation (MAD) | 315289 |
| Skewness | 0.0062439679 |
| Sum | 2.3378133 × 1011 |
| Variance | 1.7117426 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880927 | 5102 | 1.5% |
| 874084 | 4354 | 1.3% |
| 843977 | 4347 | 1.2% |
| 894304 | 4333 | 1.2% |
| 880463 | 4273 | 1.2% |
| 897696 | 4212 | 1.2% |
| 765012 | 4089 | 1.2% |
| 803553 | 4029 | 1.2% |
| 791223 | 4004 | 1.1% |
| 1050964 | 3909 | 1.1% |
| Other values (315) | 305631 |
| Value | Count | Frequency (%) |
| 1610 | 130 | < 0.1% |
| 1829 | 138 | < 0.1% |
| 1919 | 131 | < 0.1% |
| 2495 | 173 | |
| 2556 | 190 | |
| 4205 | 177 | |
| 4406 | 115 | < 0.1% |
| 6804 | 380 | |
| 7794 | 72 | < 0.1% |
| 9808 | 358 |
| Value | Count | Frequency (%) |
| 1487630 | 2975 | |
| 1450392 | 3048 | |
| 1421700 | 3564 | |
| 1344233 | 3543 | |
| 1340550 | 3441 | |
| 1332293 | 3545 | |
| 1316326 | 3463 | |
| 1300016 | 3394 | |
| 1282931 | 3576 | |
| 1267070 | 3350 |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
| Distinct | 325 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1089131.1 |
| Minimum | 1861 |
|---|---|
| Maximum | 2664062 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1861 |
|---|---|
| 5-th percentile | 46332 |
| Q1 | 404601 |
| median | 1087877 |
| Q3 | 1810515 |
| 95-th percentile | 2577611 |
| Maximum | 2664062 |
| Range | 2662201 |
| Interquartile range (IQR) | 1405914 |
Descriptive statistics
| Standard deviation | 747430.91 |
|---|---|
| Coefficient of variation (CV) | 0.68626346 |
| Kurtosis | -0.7863428 |
| Mean | 1089131.1 |
| Median Absolute Deviation (MAD) | 684872 |
| Skewness | 0.37835987 |
| Sum | 3.7932586 × 1011 |
| Variance | 5.5865297 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211797 | 5102 | 1.5% |
| 1281478 | 4354 | 1.3% |
| 1216252 | 4347 | 1.2% |
| 1315563 | 4333 | 1.2% |
| 1300429 | 4273 | 1.2% |
| 1341815 | 4212 | 1.2% |
| 1155932 | 4089 | 1.2% |
| 1205561 | 4029 | 1.2% |
| 1177018 | 4004 | 1.1% |
| 2577611 | 3909 | 1.1% |
| Other values (315) | 305631 |
| Value | Count | Frequency (%) |
| 1861 | 130 | < 0.1% |
| 2097 | 138 | < 0.1% |
| 2194 | 131 | < 0.1% |
| 2816 | 173 | |
| 3324 | 190 | |
| 4796 | 115 | < 0.1% |
| 5035 | 177 | |
| 7383 | 380 | |
| 8244 | 72 | < 0.1% |
| 10667 | 358 |
| Value | Count | Frequency (%) |
| 2664062 | 3866 | |
| 2663359 | 3793 | |
| 2618463 | 3789 | |
| 2593332 | 3843 | |
| 2577611 | 3909 | |
| 2548052 | 3890 | |
| 2479845 | 3851 | |
| 2178429 | 3757 | |
| 2062095 | 3811 | |
| 2052147 | 1168 | 0.3% |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3670 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 53854 |
| Missing (%) | 15.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3606.8565 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 140 |
| Q1 | 480 |
| median | 1255 |
| Q3 | 4190 |
| 95-th percentile | 13770 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3710 |
Descriptive statistics
| Standard deviation | 6540.5049 |
|---|---|
| Coefficient of variation (CV) | 1.8133532 |
| Kurtosis | 136.4698 |
| Mean | 3606.8565 |
| Median Absolute Deviation (MAD) | 1025 |
| Skewness | 6.9594877 |
| Sum | 1.0619632 × 109 |
| Variance | 42778204 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2088 | 0.6% |
| 105 | 1978 | 0.6% |
| 110 | 1791 | 0.5% |
| 180 | 1605 | 0.5% |
| 300 | 1594 | 0.5% |
| 185 | 1583 | 0.5% |
| 140 | 1536 | 0.4% |
| 175 | 1477 | 0.4% |
| 125 | 1400 | 0.4% |
| 165 | 1392 | 0.4% |
| Other values (3660) | 277985 | |
| (Missing) | 53854 | 15.5% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 919 | |
| 90 | 670 | 0.2% |
| 95 | 716 | 0.2% |
| 100 | 1026 | |
| 105 | 1978 | |
| 110 | 1791 | |
| 115 | 1169 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 101270 | 8 | |
| 99590 | 5 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 11 | 991900024 | 3801 | 4066 | 61915 | 80341 | 79304 | 103932 | 305.0 |
| 1 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 11 | 991900020 | 1110 | 1173 | 61915 | 80341 | 79304 | 103932 | 2260.0 |
| 2 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 13 | 991900022 | 2 | 4 | 721 | 730 | 79304 | 103932 | 825.0 |
| 3 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 12 | 991900018 | 3649 | 4042 | 17753 | 22861 | 79304 | 103932 | 440.0 |
| 4 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 11 | 991900022 | 12598 | 13887 | 61915 | 80341 | 79304 | 103932 | 825.0 |
| 5 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 12 | 991900006 | 17 | 17 | 17753 | 22861 | 79304 | 103932 | NaN |
| 6 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 11 | 991900025 | 40878 | 47362 | 61915 | 80341 | 79304 | 103932 | 290.0 |
| 7 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 13 | 991900025 | 20 | 21 | 721 | 730 | 79304 | 103932 | 290.0 |
| 8 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 12 | 991900008 | 2581 | 2655 | 17753 | 22861 | 79304 | 103932 | 460.0 |
| 9 | 1.0 | 2023-12-08 | 2023-12-01 | 2019-01-01 | 1900 | 11 | 991900023 | 60 | 61 | 61915 | 80341 | 79304 | 103932 | NaN |
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 348273 | 1.0 | 2023-12-08 | 2023-12-01 | 2014-01-01 | 303 | 160 | 129999054 | 2 | 2 | 18469 | 20470 | 1421700 | 1845601 | 1230.0 |
| 348274 | 1.0 | 2023-12-08 | 2023-12-01 | 2020-01-01 | 313 | 702 | 39999017 | 1 | 1 | 605 | 887 | 1046915 | 2618463 | 9560.0 |
| 348275 | 1.0 | 2023-12-08 | 2023-12-01 | 2015-01-01 | 362 | 347 | 990062013 | 1 | 1 | 11 | 11 | 70900 | 81597 | 620.0 |
| 348276 | 1.0 | 2023-12-08 | 2023-12-01 | 2015-01-01 | 362 | 281 | 990062008 | 2 | 2 | 80 | 83 | 70900 | 81597 | 3005.0 |
| 348277 | 1.0 | 2023-12-08 | 2023-12-01 | 2014-01-01 | 303 | 282 | 199299070 | 1 | 1 | 5068 | 5823 | 1421700 | 1845601 | 4305.0 |
| 348278 | 1.0 | 2023-12-08 | 2023-12-01 | 2014-01-01 | 303 | 344 | 28899031 | 1 | 1 | 53 | 78 | 1421700 | 1845601 | 5435.0 |
| 348279 | 1.0 | 2023-12-08 | 2023-12-01 | 2020-01-01 | 313 | 624 | 29099065 | 1 | 1 | 44 | 87 | 1046915 | 2618463 | 350.0 |
| 348280 | 1.0 | 2023-12-08 | 2023-12-01 | 2014-01-01 | 303 | 366 | 990356066 | 1 | 1 | 189 | 245 | 1421700 | 1845601 | 2320.0 |
| 348281 | 1.0 | 2023-12-08 | 2023-12-01 | 2014-01-01 | 303 | 314 | 29099016 | 1 | 1 | 259 | 288 | 1421700 | 1845601 | 12765.0 |
| 348282 | 1.0 | 2023-12-08 | 2023-12-01 | 2014-01-01 | 303 | 838 | 990356056 | 1 | 1 | 55 | 91 | 1421700 | 1845601 | 5110.0 |